package com.vm.util;

public class SQLUtils {
    public static String getPhoneInfoPageSQL(String brandPhone){
    	StringBuffer sb = new StringBuffer();
    	
    	sb.append(" from PhoneInfo where 1=1 ");
    	if(brandPhone != null ){
    		sb.append("and  piPp like '%"+brandPhone+"%'");
    	}
    	return sb.toString();
    }
    /**
     * 获取手机驱动的SQL
     * @return
     */
    public static String getDriverInfoSQL(){
    	StringBuffer sb = new StringBuffer();
    	sb.append("select distinct piPp from  PhoneInfo ");
    	return sb.toString();
    }
    
    public static String delMessageReplySQL(){
    	StringBuffer sb = new StringBuffer();
    	sb.append("delete from MessageReply mr where mr.messageBoard.lbId = ?");
    	return sb.toString();
    	
    }
}
